<?php
defined( '_VALID_MOS' ) or die('<script>window.location.href="http://www.kinifurniture.com";</script>');

$adm_functions->is_admin_login();
$section='Edit Album';
$icon_description='
<table><tr><td>
	<table cellspacing="0" cellpadding="4" border="0" align="center">
		<tr align="center">
			<td>
				<img src="show_files/publish1.png" border="0" alt="Pending" />
			</td>
			<td>
				News is <u>inactive</u> |
			</td>
			<td>
				<img src="show_files/tick.png" border="0" alt="Visible" />
			</td>
			<td>
				News is <u>active</u>  |
			</td>
			<td>
				<img src="show_files/delete.png" border="0" alt="Visible" />
			</td>
			<td>
				<u>Delete</u> News
			</td>
		</tr>
	</table>
</td></tr><tr><td align="center">
	<table cellspacing="0" cellpadding="4" border="0" align="center">
		<tr align="center">
			<td align="center">
				<i>Click on icon to toggle state or execute command.</i>
			</td>
		</tr>
	</table>
</td></tr></table>
';
$adm_menu='
<table width="100%" class="menubar" cellpadding="0" cellspacing="0" border="0">
	<tr>
		<td class="menudottedline" width="40%">
			<div class="pathway"><img src="assets/admin/'.$SITE_LOGO_ADMIN.'"/></div>	</td>
		<td class="menudottedline" align="right">
			<table cellpadding="0" cellspacing="0" border="0" id="toolbar">
				<tr valign="middle" align="center">
					<td>&nbsp;</td>
					<td>
					<a class="toolbar" href="javascript:kliksubmit();">
						<img src="show_files/save.png"  alt="Save" name="save" title="Save" align="middle" border="0" />				<br />Save</a>
					</td>
					<td>&nbsp;</td>
					<td>
						<a class="toolbar" href="admin.php?show=album_manager">
						<img src="show_files/cancel.png"  alt="Cancel" name="cancel" title="Cancel" align="middle" border="0" />				<br />Cancel</a>
					</td>
				</tr>
			</table>
		</td>
	</tr>
</table>
<br />
';

if ($id)
{
	$qryedit="select * from album where id_album=$id";
	$selectedit=$dbh->query($qryedit);

	while($sqlRowedit=mysql_fetch_object($selectedit))
	{
		$val_id_album=$sqlRowedit->id_album;
		$val_title=$sqlRowedit->nama_album;
		$val_img_album=$sqlRowedit->img_album;
		if ($val_img_album=='') $val_img_album='noimg.png';
		if ($val_img_album=='' || $val_img_album=='noimg.png')
		{
			$image='
			<input class="inputbox" type="file" name="inp_upl_img" size="25" maxlength="25" />
			';
		} else
		{
			$image='
			<input class="inputbox" type="checkbox" name="inp_del_img" value="Y" /> Delete this image <font color="green">('.$val_img_album.')</font>
			';

		}
	}
}

if($inp_title)
{
	if ($inp_del_img=='Y')
	{
		$dbh->query("update album set 
			nama_album='$inp_title', 
			img_album=''
			where id_album=$inp_id");
		@unlink("assets/album/".$inp_image);
		echo '<script>window.location.href="admin.php?show=album_manager";</script>';

	} else
	{
//$target = "upload/"; 
//$target = $target . basename( $_FILES['inp_img_uploaded']['name']) ; 
//$ok=1; 
//if(move_uploaded_file($_FILES['inp_img_uploaded']['tmp_name'], $target)) 
//{
//echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded";
//} 
//else {
//echo "Sorry, there was a problem uploading your file.";
//}


	if($_FILES['inp_upl_img']['name'])
	{
		$imageexists='N';
		$img_name=basename($_FILES['inp_upl_img']['name']);
		$qryname="select * from album where img_album='$img_name'";
		$selectname=$dbh->query($qryname);
		while($sqlRowedit=mysql_fetch_object($selectname))
		{
			$imageexists='Y';
		}
		if ($imageexists=='Y') 
		{
			echo '<script>alert("The Filename is already exists, try another filename");</script>';
		}
		else
		{
			$uploaddir = 'assets/album/';
			$uploadfile = $uploaddir . basename($_FILES['inp_upl_img']['name']);
			move_uploaded_file($_FILES['inp_upl_img']['tmp_name'], $uploadfile);
			$img_name=basename($_FILES['inp_upl_img']['name']);
			$qry_image='img_album=\''.$img_name.'\',';
		}
	} else 	$qry_image='';

	$namafileupload=$_FILES['inp_upl_img']['name'];
	if ($imageexists!='Y' && $adm_functions->checkfiletype($namafileupload))
		{
	$dbh->query("update album set 
		$qry_image
		nama_album='$inp_title'
		where id_album=$inp_id");
	echo '<script>window.location.href="admin.php?show=album_manager";</script>';
	}
	}
}
?>